"""
Case Type   : 资源池化故障模式库
Case Name   : 审计目录无权限-审计目录无权限
Create At   : 2025/04
Owner       : haomeng
Description :
    1、修改操作审计开关为全开
    2、查看集群状态
    3、运行tpcc业务
    4、修改主节点pg_audit审计目录为无权限访问状态
    5、查看业务运行情况
    6、重启集群,查看集群状态
    7、恢复pg_audit目录权限，恢复参数值
Expect      :
    1、参数设置成功
    2、集群状态正常
    3、运行业务成功
    4、修改主节点pg_audit目录权限成功
    5、业务运行正常无影响
    6、重启集群成功，集群状态正常
    7、恢复pg_audit目录权限成功，参数默认值恢复成功
History     :
"""

import os
import time
import unittest

from testcase.utils.Common import Common
from testcase.utils.CommonSH import CommonSH
from testcase.utils.ComThread import ComThread
from testcase.utils.Constant import Constant
from testcase.utils.Logger import Logger
from yat.test import Node
from yat.test import macro

class SSFauleMode(unittest.TestCase):

    def setUp(self):
        self.log = Logger()
        self.log.info(f'----{os.path.basename(__file__)} start----')
        self.user_node = [Node(node='PrimaryRoot'), Node(node='PrimaryDbUser')]
        self.pri_sh = CommonSH('PrimaryDbUser')
        self.com = Common()
        self.constant = Constant()

        self.audit_param = 'audit_system_object'

    def test_ss_faule(self):
        text = '-----step1:修改操作审计开关为全开  expect:参数设置成功-----'
        self.log.info(text)

        self.log.info('-----获取审计操作默认值-----')
        self.param_value = self.pri_sh.execut_db_sql(f'show {self.audit_param};')
        self.default_value = self.param_value.splitlines()[2].strip()
        self.log.info(self.default_value)

        result = self.pri_sh.execute_gsguc('set', self.constant.GSGUC_SUCCESS_MSG,
                                           f'{self.audit_param} = 268435455')
        self.log.info(result)
        self.assertTrue(result, '参数设置失败')

        text = '-----step2:查看集群状态;  expect:集群状态正常-----'
        self.log.info(text)

        status = self.pri_sh.exec_cm_ctl('query', '-Cv')
        self.log.info(status)
        self.assertIn('Normal', status, '集群状态异常')

        text = '-----step3:执行tpcc读写业务  expect:业务执行成功-----'
        self.log.info(text)

        tpcc_cmd = f'./runBenchmark.sh {macro.PROPS_FILENAME}'
        self.log.info(tpcc_cmd)

        tpcc_execute = ComThread(self.com.start_tpcc, args=(self.user_node[0],
                                                               f'{macro.TPCC_PATH}',
                                                               tpcc_cmd))
        tpcc_execute.setDaemon(True)
        tpcc_execute.start()

        text = '-----step4:修改主节点pg_audit目录为无权限访问状态  expect:修改成功-----'
        self.log.info(text)

        chmod = f'chmod 000 {macro.PG_AUDIT_PATH};ls -al {macro.PG_AUDIT_PATH}'
        self.log.info(chmod)

        chmod_execute = ComThread(self.com.get_sh_result, args=(self.user_node[1], chmod))
        chmod_execute.setDaemon(True)
        chmod_execute.start()

        text = '-----step5:查看业务运行情况  expect:业务运行正常无影响-----'
        self.log.info(text)

        tpcc_execute.join()
        ret1 = tpcc_execute.get_result()
        self.log.info(ret1)
        self.assertIn('Session End', ret1, 'tpcc执行失败')

        chmod_execute.join()
        ret2 = chmod_execute.get_result()
        self.log.info(ret2)
        self.assertIn('Permission denied', ret2, '修改pg_log目录权限失败')

        text = '-----step6:重启集群，查看集群状态  expect:重启成功，集群状态正常-----'
        self.log.info(text)

        restart = self.pri_sh.exec_cm_ctl('stop;', 'cm_ctl start')
        self.log.info(restart)
        self.assertIn(self.constant.cm_stop_success_msg, restart, '集群重启失败')
        self.assertIn(self.constant.cm_start_success_msg, restart, '集群重启失败')

        status = self.pri_sh.exec_cm_ctl('query', '-Cv')
        self.log.info(status)
        self.assertIn('cluster_state   : Normal', status, '集群重启失败')

    def tearDown(self):
        text = '-----step7：恢复环境状态  expect:目录权限恢复成功，参数默认值恢复成功-----'
        self.log.info(text)

        chmod = f'chmod 700 {macro.PG_AUDIT_PATH};ls -al {macro.PG_AUDIT_PATH}'
        self.log.info(chmod)
        res = self.user_node[1].sh(chmod).result()
        self.log.info(res)

        recovery = self.pri_sh.execute_gsguc('set', self.constant.GSGUC_SUCCESS_MSG,
                                             f'{self.audit_param} = {self.default_value}')
        self.log.info(recovery)
        self.assertTrue(recovery, '参数恢复失败')
        self.assertIn('drwx', res, '修改pg_log目录权限失败')
        self.log.info(f'----{os.path.basename(__file__)} end----')
